Project tools

Via the Project tools menu item a macro is started under Microsoft Excel97 which enables users to create dimensional drawings and DIN IEC or ISA form sheets.

The following description explains how to use this macro.

Directly upon accessing this menu item, a selection menu appears where you can choose the action you would like to perform with the macro.

Creating dimensional drawings:

To create dimensional drawings, you are required to insert a project table first. You can either choose the corresponding menu item, or click on the push button on the "Specification" sheet of the template. Once this action is initiated, a dialog box opens prompting you to choose and insert the desired project file. Experienced users can also insert the project table in the template "manually".

Once you have inserted the project table, you can complete it to clearly specify the individual positions. Be sure to note the abbreviations listed on the "Legend" sheet. If you change to the "Dimensions" sheet, you can enter the dimensions of the selected valves. For the assignment of the dimensions to the entries in the drawings, refer to the "Dimensional legend" sheet.

After entering all data, you can start the creation of dimensional drawings by clicking on the push button on this sheet. The drawings are then created in a new workbook where they can be further modified and printed.

Creating ISA or DIN IEC form sheets:

To create these form sheets, you can choose the corresponding menu from the main selection or click on the corresponding toolbar buttons in the Excel toolbar. After selecting a valve data table via dialog box, the form sheets are created in a separate workbook.

The form sheets created this way can now be saved, modified and printed.

The macro automatically integrates a toolbar in Excel that contains buttons for the following actions:

-Display main selection

-Insert project table

-Create dimensional drawings

-Create DIN IEC Sheets

-Create ISA Form Sheets.

When the file is closed, this toolbar disappears.